package com.lukk.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import com.lukk.pojo.InternalWorker;
import com.lukk.pojo.Province;
import com.lukk.pojo.Territory;

/**
 * 
 * ProvinceDAO 下午2:54:56 Copyright zhaocj Inc. All Rights reserved.
 * alldios@outlook.com
 *
 */
@Repository
public interface ProvinceDAO {
	public List<Province> selectUnallocatedProvinces();

	public List<Province> selectAvailableProvinces(InternalWorker internalWorker);

	public void modifyProvincesByInternalWorker(@Param("provinceIDS") Integer[] splits,
			@Param("internalWorkerID") Integer id);

	public List<Territory> selectAreaByCity(String cityCode);

	public Integer selectCountByCountry(String country);

	public Territory selectProvinceByCode(@Param("provinceCode") String provinceCode);

	public List<Territory> selectCityByProvinceCode(String provinceCode);

	public Integer selectCountByCountryCode(@Param("countryCode") String countryCode);

	public List<Province> selectUnallocatedProvincesByinternalWorker(InternalWorker internalWorker);

	public List<Province> selectProvinces();

}
